In [1]:
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import seaborn as sns
import plotly.express as px
import plotly.graph_objects as go
In [2]:
df = pd.read_excel('Failure_points.xlsx')
df.head()
Out[2]:
Reasons Failure point Percentage Percent
0 The Business Plan Loss of the original vision 0.03 3.0
1 The Business Plan Bad marketing 0.06 6.0
2 The People Inexperienced management 0.06 6.0
3 The Business Plan No traction 0.07 7.0
4 The Customer/User Unfaithful Customers 0.07 7.0
In [3]:
fig = px.bar(df, x="Percent", y="Failure point", color='Percent', width=950, height=850, 
             template="plotly_white", color_continuous_scale = "Spectral_r", title='Business Failure Reasons')
fig.update_yaxes(ticks="",showgrid=False, zeroline=True)
fig.update_xaxes(ticks="",showgrid=False, zeroline=True)
fig.update_xaxes(showspikes=True, spikecolor="pink", spikethickness=1)#spikesnap="cursor", spikemode="across")
fig.update_yaxes(showspikes=True, spikecolor="orange", spikethickness=1)
fig.update_layout(spikedistance=1000, hoverdistance=1000)
fig.update_layout(hovermode="y", 
                  hoverlabel=dict(#bgcolor="white",
                                  font_size=14,
                                  font_family="Rockwell"
                                 ))
fig.show()
In [4]:
fig = px.sunburst(df, path=['Reasons', 'Failure point'], values='Percent', width=1000, height=900, 
             template="plotly_white",color='Reasons', title='Failure points in a Business area')
fig.update_traces(textfont_size=14,textfont_color="white",leaf=dict(opacity=0.75))
fig.update_layout(hoverlabel=dict(bgcolor="white",
                                  font_size=14,
                                  font_family="Rockwell"
                                 ))
fig.show()
In [5]:
df0 = pd.ExcelFile("Failure_points1.xlsx")
df1 = pd.read_excel(df0, 'Sheet1')
df2 = pd.read_excel(df0, 'Sheet2')
df3 = pd.read_excel(df0, 'Sheet3')
df4 = pd.read_excel(df0, 'Sheet4')
df5 = pd.read_excel(df0, 'Sheet5')
In [6]:
fig1 = px.sunburst(df1, path=['Reasons', 'Failure point'], values='Percentage', width=900, height=900, 
             template="plotly_white", color_continuous_scale = "reds", color='Percentage', 
                   title='Failure points related to the Business')
fig1.update_traces(textfont_size=14,textfont_color="black",leaf=dict(opacity=0.8))
fig1.update_layout(hoverlabel=dict(bgcolor="white",
                                  font_size=14,
                                  font_family="Rockwell"
                                 ))

fig2 = px.sunburst(df2, path=['Reasons', 'Failure point'], values='Percentage', width=900, height=900, 
             template="plotly_white", color_continuous_scale = "oranges", color='Percentage',
                  title='Failure points related to the People')
fig2.update_traces(textfont_size=14,textfont_color="black",leaf=dict(opacity=0.8))
fig2.update_layout(hoverlabel=dict(bgcolor="white",
                                  font_size=14,
                                  font_family="Rockwell"
                                 ))

fig3 = px.sunburst(df3, path=['Reasons', 'Failure point'], values='Percentage', width=900, height=900, 
             template="plotly_white", color_continuous_scale = "purples", color='Percentage',
                  title='Failure points related to the Environment')
fig3.update_traces(textfont_size=14,textfont_color="black",leaf=dict(opacity=0.8))
fig3.update_layout(hoverlabel=dict(bgcolor="white",
                                  font_size=14,
                                  font_family="Rockwell"
                                 ))

fig4 = px.sunburst(df4, path=['Reasons', 'Failure point'], values='Percentage', width=900, height=900, 
             template="plotly_white", color_continuous_scale = "blues", color='Percentage',
                  title='Failure points related to the Product')
fig4.update_traces(textfont_size=14,textfont_color="black",leaf=dict(opacity=0.8))
fig4.update_layout(hoverlabel=dict(bgcolor="white",
                                  font_size=14,
                                  font_family="Rockwell"
                                 ))

fig5 = px.sunburst(df5, path=['Reasons', 'Failure point'], values='Percentage', width=900, height=900, 
             template="plotly_white", color_continuous_scale = "greens", color='Percentage',
                  title='Failure points related to the Customer/User')
fig5.update_traces(textfont_size=14,textfont_color="black",leaf=dict(opacity=0.8))
fig5.update_layout(hoverlabel=dict(bgcolor="white",
                                  font_size=14,
                                  font_family="Rockwell"
                                 ))
fig1.show()
fig2.show()
fig3.show()
fig4.show()
fig5.show()
In [8]:
Reasons=df['Failure point']
Percent=df['Percent']
fig = go.Figure(data=[go.Pie(labels=Reasons, values=Percent, insidetextorientation='radial', 
                            title='Failure points in decreasing order Pie-chart', titlefont_size=20)])
fig.update_traces(hoverinfo='label+value', textinfo='label', textfont_size=12,
                  marker=dict(colors=Percent), showlegend=False, )
fig.update_layout(hovermode="y", height=950, width=1000,
                  hoverlabel=dict(bgcolor="white",
                                  font_size=16,
                                  font_family="Rockwell"
                                 ))
fig.show()
In [ ]: